Mark Cronk ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	38

About Me

About Me

Linkedin	https://www.linkedin.com/in/col-r-mark-cronk-35106513

Analytics

1,319

Posts

1,112

Visits

12.7k

Points

Sep 16, 2020

Join Date

Nov 20, 2024

Last Active

Reactions

• Insightful 121

  121
• Vote Up 159

  159
• Awesome 3

  3

• Activity
• Discussions
• Comments1.3K

• Re: How would you extract a number from a cell that contains text and numbers?

  Mark Cronk

  02/06/21
  Hi @Jerell Parker , There are several ways to do this. If the number is always the same number of characters and in the same position you can do: =VALUE(LEFT([text-num]@row, 6)) where [text-num] is t…
  6 ·

• Re: How to Count Multiple Drop Down Values

  Mark Cronk

  01/05/21
  Hi @Miles Allison , There are 2 unique functions in Smartsheet to deal with multiple select fields; HAS and COUNTM. COUNTM: Counts the number of elements in a multi-contact or multi-select dropdown c…
  1 ·

• Re: Health Status Formula dependent on due date

  Mark Cronk

  05/14/21
  Hi Ali, Does this work for you? =IF[On Hold] = 1, "Gray", IF(OR([Due Date]@row >= TODAY(15), Status@row="Completed"), "Green", IF([Due Date]@row < TODAY(3), "…
  1 ·